<%-- 
    Document   : myresumes
    Created on : Apr 4, 2012, 3:41:18 PM
    Author     : project
--%>


<%@page import="jobportal.Dbconn"%>
<%@page import="java.sql.*" %>
<%@include file="header.jsp"%>
<%
            Connection con = null;
            Statement st = null;
            ResultSet rs = null;
            String username = request.getParameter("username");
            String resumetitle = "", name = "", gender = "", dob = "", nationality = "", address = "", city = "", state = "", pin = "", contact = "", email = "";
            String employer = "", industry = "", role = "", salary = "0", exp = "0";
            String des_industry = "", des_fun_area = "", des_keyskill = "", des_salary = "";
            try {
                con = Dbconn.getConn();
                st = con.createStatement();

                String sql = "select * from student where username='" + username + "'";
                rs = st.executeQuery(sql);
                if (rs.next()) {
                    name = rs.getString("name");
                    gender = rs.getString("gender");
                    dob = rs.getString("dob");
                    address = rs.getString("address");
                    email = rs.getString("email");
                    city = rs.getString("city");
                    state = rs.getString("state");
                    pin = rs.getString("pin");
                    contact = rs.getString("contact");
                    nationality = rs.getString("nationality");
                }
                sql = "select * from exprience where username='" + username + "'";
                rs = st.executeQuery(sql);
                if (rs.next()) {
                    employer = rs.getString("employer");
                    industry = rs.getString("industry");
                    role = rs.getString("role");
                    salary = rs.getString("salary");
                    exp = rs.getString("exp");
                }
                sql = "select * from desiredjob where username='" + username + "'";
                rs = st.executeQuery(sql);
                if (rs.next()) {
                    des_industry = rs.getString("industry");
                    des_fun_area = rs.getString("fun_area");
                    des_salary = rs.getString("salary");
                    des_keyskill = rs.getString("keyskill");
                }
                sql = "select * from education where username='" + username + "' order by year desc";
                rs = st.executeQuery(sql);
            } catch (Exception e) {
                out.println("Exception::" + e);
            }


%>
<td height="auto" rowspan="4" align="left" valign="top" style="height:auto; padding:5px;">
    <br>
    
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr><td class="messagesred">
            </td></tr>
        <tr>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td>	<div>
                    <table width="100%" border="0" cellspacing="0" cellpadding="0" >

                        <tr>
                            <td width="72%" >Candidate Profile </td>
                        </tr>
                    </table>
                    <img src="../images/blank.gif" alt="blank" width="18" height="10" border="0" /><br>
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">


                        <tr>
                            <td width="50%" height="20" align="center" valign="top" style="padding-left:5px; padding-left:5px;"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" colspan="5" align="left" style="padding-left:5px;" class="sde_mnu_hdr_blue" ><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/><strong>General Details </strong> </td>
                                    </tr>
                                    <tr >
                                        <td width="6%" height="20"  style="padding-left:5px;">&nbsp;</td>
                                        <td width="27%" align="left"  style="padding-left:2px;">Resume Title</td>
                                        <td width="3%" align="center" >:</td>
                                        <td width="41%" align="left"  style="padding-left:5px; text-transform:capitalize;"><span style="padding-left:5px;"><%=resumetitle%></span></td>
                                        <td width="23%" rowspan="5" align="center" valign="top"  style="padding-left:1px; padding-right:5px;">
                                            <img src="../src/getpic.jsp?id=<%=request.getParameter("username")%>&table=student&col=photo&pk_col=username" width="90" height="90" border="0" /></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Name</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=name%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Gender</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=gender%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">DOB</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=dob%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Nationality</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=nationality%></td>
                                    </tr>
                                </table></td>
                            <td width="50%" align="center" valign="top" style="padding-left:5px; padding-left:5px;"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" colspan="4" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/>Contact  Details </strong> </td>
                                    </tr>
                                    <tr>
                                        <td width="6%" height="20"  style="padding-left:5px;">&nbsp;</td>
                                        <td width="22%" align="left"  style="padding-left:2px;">Address</td>
                                        <td width="4%" align="center" >:</td>
                                        <td width="68%" align="left"  style="padding-left:5px;"><%=address%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                                        <td align="center" >&nbsp;</td>
                                        <td align="left"  style="padding-left:5px;"><%=city%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                                        <td align="center" >&nbsp;</td>
                                        <td align="left"  style="padding-left:5px;"><%=state%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">&nbsp;</td>
                                        <td align="center" >&nbsp;</td>
                                        <td align="left"  style="padding-left:5px;">Pin: <%=pin%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Email</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=email%><img src="../images/i_error.gif" /> </td>
                                    </tr>

                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Mobile</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=contact%><img src="../images/i_error.gif" /> </td>
                                    </tr>
                                </table></td>
                        </tr>
                        <tr>
                            <td height="5" colspan="2" align="center" valign="middle"></td>
                        </tr>

                        <tr>
                            <td height="5" colspan="2" align="center" valign="middle"></td>
                        </tr>
                        <tr>
                            <td height="20" align="center" valign="top" style="padding-left:5px; padding-left:5px;"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" colspan="4" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/>Current Employment Details </strong> </td>
                                    </tr>
                                    <tr>
                                        <td width="5%" height="20"  style="padding-left:5px;">&nbsp;</td>
                                        <td width="39%" align="left"  style="padding-left:2px;">Current Employer</td>
                                        <td width="3%" align="center" >:</td>
                                        <td width="53%" align="left"  style="padding-left:5px;"><%=employer%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Current Industry</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=industry%></td>
                                    </tr>

                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Current Job Role</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=role%></td>
                                    </tr>

                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Current Annual Salary</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px; text-transform:capitalize;"><span style="padding-left:5px;"><span style="padding-left:5px;vertical-align:middle"><img src="../images/rupee.jpg" width="16" height="17"/></span><%=salary%> INR.</span></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Total Year of Experience </td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=exp%> in Years.</td>
                                    </tr>

                                </table></td>
                            <td align="center" valign="top" style="padding-left:5px; padding-left:5px;"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" colspan="4" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/>Desired Employment Details </strong> </td>
                                    </tr>
                                    <tr>
                                        <td width="5%" height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td width="39%" height="22" align="left"  style="padding-left:2px;">Desired Industry </td>
                                        <td width="3%" align="center" >:</td>
                                        <td width="53%" align="left"  style="padding-left:5px;"><%=des_industry%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Desired Functional Area</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=des_fun_area%></td>
                                    </tr>
                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Key Skills </td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px;"><%=des_keyskill%></td>
                                    </tr>

                                    <tr>
                                        <td height="22"  style="padding-left:5px;">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;">Desired Annual Salary</td>
                                        <td align="center" >:</td>
                                        <td align="left"  style="padding-left:5px; text-transform:capitalize;">Anually<span style="padding-left:5px;vertical-align:middle"><img src="../images/rupee.jpg" width="16" height="17"/></span> <span style="padding-left:5px;"><%=des_salary%></span></td>
                                    </tr>

                                </table></td>
                        </tr>
                        <div style="padding-top:15px;"><!-- --></div>
                        <tr>
                            <td height="20" align="center" valign="top" style="padding-left:5px; padding-left:5px;" colspan="2">



                                <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tbl_bdr medium_font">
                                    <tr>
                                        <td height="20" colspan="4" align="left" class="sde_mnu_hdr_blue" style="padding-left:5px;"><strong><img style="margin-top:2px; margin-left:-2px;" src="../images/top_left.gif"; class="sde_mnu_img2"/>Academic   Details </strong> </td>
                                    </tr>

                                    <tr>
                                        <td height="22"  style="padding-left:5px;" width="3%">&nbsp;</td>
                                        <td height="22" align="left"  style="padding-left:2px;" colspan="2"><table width="100%" border="0" cellspacing="0" style="text-align:center" class="tbl_bdr medium_font">
                                          <tr class="sde_mnu_hdr_blue" style="background-color: lightskyblue">
                                            <td>course</td>
                                            <td>university/school</td>
                                            <td>stream</td>
                                            <td>year</td>
                                            <td>% Marks </td>
                                          </tr>
                                          <%while (rs.next()) {%>
                                          <tr>
                                            <td><%=rs.getString("course")%></td>
                                            <td><%=rs.getString("univ")%></td>
                                            <td><%=rs.getString("stream")%></td>
                                            <td><%=rs.getString("year")%></td>
                                            <td><%=rs.getString("marks")%>%</td>
                                          </tr>
                                          <%}%>
                                          <tr class="sde_mnu_hdr_blue" style="background-color: lightskyblue">
                                            <td>&nbsp;</td>
                                            <td>&nbsp;</td>
                                            <td>&nbsp;</td>
                                            <td>&nbsp;</td>
                                            <td>&nbsp;</td>
                                          </tr>
                                        </table></td>
                                        <td height="22" align="left"  style="padding-left:2px;" width="3%">&nbsp;</td>
                                  </tr>
                                  <tr><td>&nbsp;</td></tr>
                                </table>
                            </td>
                        </tr>
                    </table>
                </div></td>
        </tr>
    </table>
</td>
<%@include file="footer.jsp"%>